sisHYD import of HR data
The following section describes the structure of text files for an import using the sisHYD text interface. The GIS sisNET exports network data in the text format described.
Specification of the import text interface
- The file consists of a series of data blocks, where each data block describes exactly one object
- A data block is introduced with a keyword. On the following lines pairs of field keyword and value are listed, which are separated from each other by exactly one TAB. Keyword and value must be present.
- Keywords are written exclusively in CAPITAL LETTERS.
- A block is completed by a blank line (this also applies for the last block of the text file).
- All unit-bound dimensions are entered in the unit which is described in the sisHYD database sketch. In general, these are the SI units (length, diameter in [m], performance in [W], flow rates in [Nm3/s], mass flows in [kg/s], temperature in [°C]).
- Numeric values are displayed as cultural neutral formatting, i.e. a point is used as a separator, there is no thousand separator.
- All compulsory fields must be listed for a block. Compulsory field which run a default value are excepted. If the compulsory field is missing it is taken up with the default value.
- Date and numerical data take place in the UTC format
- (YYYY-MM-DD HH:MM:SSZ), e.g.: 2008-11-21 14:28:13Z.
sisHYD imports the following data blocks (grey) from the import file
- All keywords of the import interface are strictly identical to the corresponding column names of the database draft.
- Keywords in curly brackets are alternative names (old) which are still understood by the import format. They deviate from the convention and are replaced with by names that conform to convention for import files with format information.
- The order of the data
blocks is arbitrary in the old format. In the new format the first block is the
VERSION. For all further blocks, data which are referenced are to be written
before blocks which depend on these data. (e.g. Write pipe classes before pipe
data which reference the pipe class).
Note: For compatibility reasons the order is not yet checked. The integrity examination therefore only takes place when the project is opened by sisHYD. Incorrect data are announced and eliminated from the database.Note: From sisHYD version 08.05.01.13, default data are generated for the following tables if no row is present after the import.
Table 1
Block/field link | Keyword Database | Compulsory | Default |
---|---|---|---|
File format (not in database) | VERSION | ||
Identification | VERSION_ID | Yes | 080904 |
"Network" | NETZ | ||
Name | NETZ_ID | Yes | |
Number | NETZ_NR | Yes | 1 |
Type of network (displays the number of leaders; for gas/water always 1) | NETZTYP | Yes | 2 |
Medium | MEDIUM | Yes | 0 |
Connection load | ANSCHLUSS_LAST | 0 | |
Max. Pressure | P_NENN | 1600000 | |
Max. Flow temperature | TMAX_VORLAUF | 130 | |
Max. Return temperature | TMAX_RUECKLAUF | 90 | |
Height of the air pressure measurement | NULLPUNKT | 0 | |
Absolute pressure | ABSOLUTDRUCK | J | |
Atmospheric pressure | LUFTDICHTE | 1.293 | |
Air pressure | LUFTDRUCK | 101325 |
Table 2
Block/field Database link | Keyword | Compulsory | Default |
---|---|---|---|
Zone | H_NETZTEIL | ||
Name | NETZTEIL_ID | Yes | |
Number | NETZTEIL_NR | Yes | 1 |
Barrier | SPERRE | ||
Correction wall roughness | WANDRAUH_KORR | 0 | |
Correction factor for the wall roughness | WANDRAUH_FAKTOR | 1 | |
Coefficient for correction of the heat transition coefficient | WAERME_KOEFF_KORR | 0 | |
Factor for correction of the heat transition coefficient | WAERME_KOEFF_FAKTOR | 1 | |
Const. Length addition | LAENGEN_ZUSCHLAG | 0 | |
Factor for the length addition | LAENGENZUSCHLAG_FAKTOR | 1 | |
Alternative | H_VARIANTE | ||
Name | VARIANTE_ID | Yes | |
Number | VARIANTE_NR | Yes | 1 |
Description | BESCHREIBUNG | ||
Alternative zone allocation | H_VARIANTE_NETZTEIL | ||
Number of the variable | VARIANTE_NR | Yes | |
Number of the contained power supply unit | NETZTEIL_NR | Yes | |
Node | KNOTEN | ||
Name | KNOTEN_ID | Yes | |
Number | KNOTEN_NR | Yes | |
Assigned network | NETZ_NR | Yes | 1 |
Network position | NETZ_POSITION | Yes | 0 |
x-coordinate | X_KOORD | Yes | |
y-coordinate | Y_KOORD | Yes | |
z-coordinate | Z_KOORD | Yes | |
Generated | GENERIERT | 1 | |
Amendment date | GEAENDERT | ||
Creation date | ERSTELLT | ||
Object identification from GIS | GISID (MS_LINK) |
Table 3
Block/field Database link | Keyword | Compulsory | Default |
---|---|---|---|
(common element data) | (ELEMENT) - !no valid data block! | ||
Name | ELEM_ID | Yes | |
Number | ELEM_NR | Yes | |
Initial node | ANFANGS_NR | Yes | 1 |
End node | END_NR | Yes | 1 |
Assigned network | NETZ_NR | Yes | 1 |
Assigned zone | HIERARCHIE | Yes | 1 |
Network position | NETZ_POSITION | Yes | 0 |
Generated | GENERIERT | 1 | |
Amendment date | GEAENDERT | ||
Creation date | ERSTELLT | ||
Object identification from GIS | GISID - (MS_LINK) | ||
Steam trap | H_STEAMTRAP - < ELEMENT | ||
Efficiency | EFFICIENCY | Yes | |
Pipe | ROHR {STRANG} - < ELEMENT | ||
Pipe class | ROHRKLASSEN_NR | Yes | 1 |
Length | LAENGE | Yes | 1.0 |
Additional resistance | ZUSATZWIDER | 0 | |
Default of an individual exterior temperature [°C], the value -1000 stands for no default | T_AUSSEN | Yes | -1000 |
Price category | PREISKATEGORIE | 1 | |
Can be isolated | IST_ABSPERRBAR | Yes | N |
Pump | PUMPE - < ELEMENT | ||
Assigned pump type, - 0 for default pump type | PUMPENTYP_NR - {PUMPENTYP} | 0 | |
Cost factor | KOSTENFAKTOR | ||
Price category | PREISKATEGORIE | 1 |
Table 4
Block/Field Database link | Keyword | Compulsory | Default |
---|---|---|---|
Valve | VENTIL {ARMATUR} - < ELEMENT | ||
Assigned valve type, 0 for type of default valve | VENTILTYP_NR - {VENTILTYP} | 0 | |
Price category | PREISKATEGORIE | ||
Supplier | VERSORGER {EINSPEISER} - < ELEMENT | ||
Max. Feeding temperature | MAX_TEMP | 0 | |
Const. pressure loss portion | DRUCKVERLUST | 0 | |
Resistance | WIDERSTAND | 0 | |
Resistance2 | WIDERSTAND2 | 0 | |
Max. Feed performance | MAX_LEISTUNG | 0 | |
Max. mass flow. | MAX_MSTROM | 0 | |
Max. Flow rate | MAX_VSTROM | 0 | |
Heat production costs | WAERME_KOSTEN | 0 | |
Consumer | VERBRAUCHER - < ELEMENT | ||
Name | ELEM_ID | Yes | |
Number | ELEM_NR | Yes | |
Nominal mass flow | NENNMASSENSTROM | ||
Connection load | ANSCHLUSSLAST | ||
Flow rate | VOLUMENSTROM | ||
Assigned consumer group | GRUPPEN_NR | Yes | 1 |
Min. pressure loss | V_MIN_DRUCKVERLUST | 0 | |
Max. pressure loss | V_MAX_DRUCKVERLUST | 0 | |
Max. mass flow. | V_MAX_MSTROM | 0 | |
Min. Flow temperature | V_MIN_VORLAUFTEMP | 0 | |
Min. pressure height | MIN_DRUCKHOEHE | 0 | |
Max. pressure height | MAX_DRUCKHOEHE | 0 | |
Bypass diameter | BYPASS | 0 |
Table 5
Block/field - Database link | Keyword | Compulsory | Default |
---|---|---|---|
Pipe inflexion points | KNICKPUNKTE | ||
Number | ELEM_NR | Yes | |
Serial inflexion point number (start each ELEM_NR with 1) | KNICK_NR | Yes | |
x-coordinate | X_KOORD | ||
y-coordinate | Y_KOORD | ||
z-coordinate | Z_KOORD | ||
Customer | VERBR_DATEN {KUNDE} | ||
Creation date | ERSTELLT | ||
Amendment date | GEAENDERT | ||
Generated | GENERIERT | 1 | |
Name | VERBRAUCHER_ID | Yes | |
Number | VERBRAUCHER_NR | Yes | |
Connection node | ANFANGS_KNR1 | Yes | |
Mass flow heating | MASSENSTROM | 0 | |
Connection value heating | NENNLEISTUNG | 0 | |
Volume flow heating | VOLUMENTSTROM | 0 | |
Consumer group heating | GRUPPEN_NR | Yes | 1 |
Volume flow consumer group | MASSENSTROM2 | 0 | |
Connection value water production | NENNLEISTUNG2 | 0 | |
Volume flow water production | VOLUMENTSTROM2 | 0 | |
Consumer group water production | GRUPPEN_NR2 | Yes | 1 |
Mass flow ventilation | MASSENSTROM3 | 0 | |
Connected load ventilation | NENNLEISTUNG3 | 0 | |
Volume flow ventilation | VOLUMENTSTROM3 | 0 | |
Consumer group ventilation | GRUPPEN_NR3 | Yes | 1 |
Current amount of heat | WAERMEMENGE1 - (WAERMEMENGE_1) | ||
Current quantity of water | WASSERMENGE1 - (WASSERMENGE_1) | ||
Current volume | VOLUMEN1 - (VOLUMEN_1) | ||
Amount of heat previous year | WAERMEMENGE2 - (WAERMEMENGE_2) | ||
Quantity of water previous year | WASSERMENGE2 - (WASSERMENGE_2) |
Table 6
Block/field Database link | Keyword | Compulsory | Default |
---|---|---|---|
Volume previous year | VOLUMEN2 - (VOLUMEN_2) | ||
Floor space | WOHNFLAECHE | ||
Bypass diameter | BYPASS | ||
First name | VORNAME | ||
Surname | HAUSNAME | ||
Street name | STRASSE | ||
Street number | HAUSNUMMER | ||
Postal/zip code | PLZ | ||
City | ORT | ||
First telephone number | TEL_PRIVAT | ||
Second telephone number | TEL_ARBEIT | ||
MESS_TYP | |||
MESS_INSTALLATION | |||
INSPEKTION | |||
Code for the consumption accounting | ABRECHNUNG | ||
Minimum building height | MIN_HOEHE | ||
Maximum building height | MAX_HOEHE | ||
SPEICHER | |||
TAUSCHER | |||
DURCHLAUF | |||
ALTERNATIV | |||
Consumer group | VERBR_GRUPPE | ||
Creation date | ERSTELLT | ||
Amendment date | GEAENDERT | ||
Generated | GENERIERT | 1 | |
Name | GRUPPEN_ID | Yes | |
Number | GRUPPEN_NR | Yes | |
Factor heating portion | FAKTOR | 1 | |
Target temperature flow | VORLAUF_SOLL | 100 | |
Target temperature return | RUECKLAUF_SOLL | 50 | |
Sigma flow | SIGMA_VORLAUF | 0 | |
Sigma load | SIGMA_LAST | 0 | |
Retention time correction | VERWEILZEIT | 0 | |
Min. Difference of pressure | DIFFDRUCK_MIN | 0 | |
Min. Flow temperature | TMIN_VORLAUF | 0 |
Table 7
Block/field Database link | Keyword | Compulsory | Default |
---|---|---|---|
Max. pressure at the customer | P_MAX_ABNEHM | 0 | |
Min. pressure height at the customer | MIN_DRUCKHOEHE | 0 | |
Max. pressure height at the customer | MAX_DRUCKHOEHE | 0 | |
Consumption field with customer data | VERBRAUCHSART | 0 | |
Yearly hours | JAHRESSTUNDEN | 0 | |
Identifies the target consumption field at the consumer | MEMO_NR | 0 | |
MITMENGENBEGRENZUNG | 0 | ||
MENGENFAKTOR | 1 | ||
Pipe class | ROHRKLASSEN | ||
Creation date | ERSTELLT | ||
Amendment date | GEAENDERT | ||
Generated | GENERIERT | 1 | |
Name | ROHRKLASSEN_ID | Yes | |
Number | ROHRKLASSEN_NR | Yes | 1 |
Inside diameter | INN_DMESS | Yes | |
Outside diameter | AUSSENDURCHMESSER {AUSS_DMESS} | ||
Retention coefficient | VERWEIL_KOEFF | Yes | 1 |
Consider in design calculations | DIMENSIONIERBAR | Yes | J |
Wall roughness | WANDRAU | 1.0001 | |
Heat coefficient | WAERME_KOEFF | ||
Heat transition coefficient | KWERT | ||
DRUCKSTUFE | |||
LIEFERANT | |||
BESTELL_NR | |||
LECKDETEKT | |||
NENNDURCHMESSER | |||
AUSSENDURCHMESSER | |||
MANTELDURCHMESSER | |||
WANDSTAERKE - {WANDDICKE} | |||
MATERIAL | |||
ISOLIERUNG | |||
GEWICHT |
Table 8
Block/field Database link | Keyword | Compulsory | Default |
---|---|---|---|
Prices for category 1 | PREIS1 | ||
Prices for category 2 | PREIS2 | ||
Prices for category 3 | PREIS3 | ||
Prices for category 4 | PREIS4 | ||
Prices for category 5 | PREIS5 | ||
Prices for category 6 | PREIS6 | ||
GESCHW_MAX | |||
DELTAP_MAX | |||
VERLEGEART | |||
AUSSENTEMPERATUR | |||
Flex pipe, J/N | FLEXROHR | ||
RILLENTIEFE | |||
RILLENABSTAND | |||
Type of pump | PUMPENTYP | ||
Creation date | ERSTELLT | ||
Amendment date | GEAENDERT | ||
Generated | GENERIERT | 1 | |
Name | PUMPENTYP | Yes | |
Number | PUMPENTYP_NR | Yes | |
NENNDREHZAHL | Yes | ||
MAX_FOERDERSTROM | |||
MIN_FOERDERSTROM | |||
MAX_DREHZAHL | 2000 | ||
MIN_DREHZAHL | 1 | ||
G_WIRK_MIN | |||
G_WIRK_MAX | |||
HOEHE0 | 0 | ||
HOEHE1 | 0 | ||
HOHE2 | 0 | ||
LEISTUNG0 | 0 | ||
LEISTUNG1 | 0 | ||
LEISTUNG2 | 0 | ||
LEISTUNG3 | 0 | ||
NPSH0 | 0 | ||
NPSH1 | 0 | ||
NPSH2 | 0 |
Table 9
Block/field Database link | Keyword | Compulsory | Default |
---|---|---|---|
NPSH3 | 0 | ||
MOTORLEISTUNG | |||
PUMPENMODELL | |||
LIEFERANT | |||
BESTELL_NR | |||
Prices for category 1 | PREIS1 | ||
Prices for category 2 | PREIS2 | ||
Prices for category 3 | PREIS3 | ||
Prices for category 4 | PREIS4 | ||
Prices for category 5 | PREIS5 | ||
Prices for category 6 | PREIS6 | ||
Creation date | ERSTELLT | ||
Amendment date | GEAENDERT | ||
Generated | GENERIERT | 1 | |
Pump characteristic entry | PUMPENKENNLINIEN | ||
Number | PUMPENTYP_NR | Yes | |
Mass flow | MASSENSTROM | Yes | |
Delivery height | FOERDERHOEHE | Yes | |
Performance | LEISTUNG | 0 | |
NPSH | NPSH | 0 | |
Valve type | VENTILTYP | ||
Creation date | ERSTELLT | ||
Amendment date | GEAENDERT | ||
Generated | GENERIERT | 1 | |
Name | VENTILTYP | Yes | |
Number | VENTILTYP_NR | Yes | |
Kvs | KVS | ||
Kvs_Kv0 | KVS_KV0 | ||
linear equal percentage freely defined check valve | KENNLINIENART |
Table 10
Block/field Database link | Keyword | Compulsory | Default |
---|---|---|---|
Prices for category 1 | PREIS1 | ||
Prices for category 2 | PREIS2 | ||
Prices for category 3 | PREIS3 | ||
Prices for category 4 | PREIS4 | ||
Prices for category 5 | PREIS5 | ||
Prices for category 6 | PREIS6 | ||
Valve model | VENTILMODELL | ||
Order_no. | BESTELL_NR | ||
Supplier | LIEFERANT | ||
Valve characteristic entry | VENTIL_KENNLINIE | ||
Number | VENTILTYP_NR | Yes | |
Position | VENTIL_STELLUNG | Yes | |
Valve coefficient | VENTIL_KOEFF | Yes | |
Organization group | ORG_GRUPPE | ||
Name | ORG_ID | Yes | |
Number | ORG_NR | Yes | |
Factor | FAKTOR | 1 | |
Special fittings | H_EINBAUTEILE | ||
Number | TEIL_NR | Yes | |
Name | TEIL_ID | Yes | |
Zeta value | ZETAWERT | Yes | |
Special fittings pipe | H_EINBAUTEILE_ROHR | ||
Number | ELEM_NR | Yes | |
Partial identification | TEIL_NR | Yes | |
Number | ANZAHL | Yes |
References to fields
- All data blocks
- Number – The number is the primary key and must be unique within all objects of a data block. Numbers always begin with 1.
- • The data blocksSTRANG, VERBRAUCHER, VERSORGER, PUMPE, VENTIL, H_STEAMTRAP inherit the data from the ELEMENT data block. The field must be unique within all objects which inherit from
- ELEMENT!
- The inheritance is marked in the keyword column with the following line "< ELEMENT".
- Conductor networks
- Pipe class
- INN_DMESS – The inside diameter is calculated if the fields for wall thickness and outside diameter are present.
- KWERT – When this is available, the field WAERME_KOEFF from KWERT is calculated using the formula:
- TheKWERT is carried out in the unit [W/mK]. This value must not be confused with the heat conductivity of the pipe insulating material! The fieldKWERT should not be defined together with the field WAERME_KOEFF.
- WAERME_KOEFF – The heat transition coefficient of the pipe class in the Unit [W/m2K].
- Steam trap – (only for long-distance heating one and two-leader networks)
New format
The format extends the existing specification with the following information.
- Format Info
- General
- Name – The name must
be unique within all objects within a type of data block. Special rules are
valid for the data blocksKNOTEN and the blocks inheriting fromELEMENT.
- Here the name must be unique in combination with the network position.
- The combination of name and network position only plays a role in the category long-distance heating.
- Here node and pipe symmetries are illustrated by the fact that supply and return nodes receive the same name with different network positions. When they are transferred into the sisHYD database the network position abbreviations are added to the names (Network position identification: Supply (V), Return, KLB), so that the database-internal name is still unique. In the dialog masks the last letter is automatically hidden with nodes and pipes.
- With conductor systems all node and pipe names contain a V contain as the last letter.
- Name – The name must
be unique within all objects within a type of data block. Special rules are
valid for the data blocksKNOTEN and the blocks inheriting fromELEMENT.